<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
	<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252">
	<TITLE></TITLE>
	<META NAME="GENERATOR" CONTENT="OpenOffice.org 2.2  (Win32)">
	<META NAME="AUTHOR" CONTENT="L Ward">
	<META NAME="CREATED" CONTENT="20091203;16001772">
	<META NAME="CHANGED" CONTENT="20091218;6172066">
	<STYLE TYPE="text/css">
	<!--
		@page { size: 8.5in 11in; margin: 0.79in }
		P { margin-bottom: 0.08in }
	-->
	</STYLE>
</HEAD>
<BODY LANG="en-US" DIR="LTR">
<P STYLE="margin-bottom: 0in"><B>Enabling Remote Access for
PostgreSQL</B></P>
<P STYLE="margin-bottom: 0in"><I><B>Allow TCP/IP Connections</B></I></P>
<P STYLE="margin-bottom: 0in">You need to edit the PostgreSQL
configuration file using any text editor (like Notepad)</P>
<P STYLE="margin-bottom: 0in"> C:\Program
Files\PostgreSql\data\postgresql.conf or
C:\PostgreSql\data\postgresql.conf</P>
<P STYLE="margin-bottom: 0in"><BR>
</P>
<P STYLE="margin-bottom: 0in">Change the following configuration line
to match the following if it is not already.</P>
<P STYLE="margin-bottom: 0in">listen_addresses='*'</P>
<P STYLE="margin-bottom: 0in"><BR>
</P>
<P STYLE="margin-bottom: 0in"><BR>
</P>
<P STYLE="margin-bottom: 0in"><I><B>Enable Clients</B></I></P>
<P STYLE="margin-bottom: 0in">Edit the file: pg_hba.conf  with any
text editor, like Notepad.</P>
<P STYLE="margin-bottom: 0in">	C:\PostgreSql\data\pg_hba.conf	or
C:\Program Files\PostgreSql\data\pg_hba.conf</P>
<P STYLE="margin-bottom: 0in"><BR>
</P>
<P STYLE="margin-bottom: 0in">Append the following configuration
lines to give access to everyone 0.0.0.0/0 . This can be configured
to be ip specific or for a set of ip addresses. Consult the
Postgresql documentation for more options.</P>
<P STYLE="margin-bottom: 0in">	host all all 10.0.0.0/0 trust</P>
<P STYLE="margin-bottom: 0in"><BR>
</P>
<P STYLE="margin-bottom: 0in"><A HREF="http://www.postgresql.org/docs/8.4/static/runtime-config-connection.html">http://www.postgresql.org/docs/8.4/static/runtime-config-connection.html</A></P>
<P STYLE="margin-bottom: 0in"><A HREF="http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html">http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html</A></P>
<P STYLE="margin-bottom: 0in"><BR>
</P>
<P STYLE="margin-bottom: 0in"><I><B>Alternative</B></I></P>
<P STYLE="margin-bottom: 0in">Both of these settings can be changed
using pgAdmin III, which installs with PostgreSQL. Select
Tools-&gt;Server Configuration-&gt;postgresql.conf  or  pg_hba.conf</P>
<P STYLE="margin-bottom: 0in"><BR>
</P>
<P STYLE="margin-bottom: 0in"><B>Troubleshooting</B></P>
<P STYLE="margin-bottom: 0in"><I><B>Unable to connect to the server.</B></I></P>
<OL>
	<LI><P STYLE="margin-bottom: 0in">Verify that the port 5432 is not
	blocked by a firewall. This can occur in one of two ways.</P>
	<OL>
		<LI><P STYLE="margin-bottom: 0in">The Windows Firewall is running
		and does not have an exception for the port. This can be set under
		Control Panel.</P>
		<LI><P STYLE="margin-bottom: 0in">The network on which it is being
		run blocks the port. Your network administrator will have to open
		this port or you can change the port to use to a more common port,
		like 8000.</P>
	</OL>
</OL>
</BODY>
</HTML>